create external table jms_dim.dim_indicator_data_config_dt
(
id             string comment '主键id'
,target_rate    string comment '达成率'
,site_code      string comment '转运中心编码'
,site_name      string comment '转运中心'
,month_day      string comment '年月'
,modify_by      string comment '修改人'
,modify_time    string comment '修改时间'
,delete_flag    string comment '删除标识  已删除：y，未删除：n'
)comment  '转运中心指标数据配置'
PARTITIONED BY (`dt` string COMMENT '时间分区(yyyy-MM-dd) ')
stored as parquet
LOCATION
  '/dw/hive/jms_dim.db/external/dim_indicator_data_config_dt';